package nsu.edu.zsq.dao;

import java.util.List;
import nsu.edu.zsq.bean.Teacher;
import nsu.edu.zsq.bean.TeacherExample;
import org.apache.ibatis.annotations.Param;

public interface TeacherMapper {
    /**
     *
     */
    long countByExample(TeacherExample example);

    /**
     *
     */
    int deleteByExample(TeacherExample example);

    /**
     *
     */
    int deleteByPrimaryKey(Integer id);

    /**
     *
     */
    int insert(Teacher record);

    /**
     *
     */
    int insertSelective(Teacher record);

    /**
     *
     */
    List<Teacher> selectByExample(TeacherExample example);

    /**
     *
     */
    Teacher selectByPrimaryKey(Integer id);

    /**
     *
     */
    int updateByExampleSelective(@Param("record") Teacher record, @Param("example") TeacherExample example);

    /**
     *
     */
    int updateByExample(@Param("record") Teacher record, @Param("example") TeacherExample example);

    /**
     *
     */
    int updateByPrimaryKeySelective(Teacher record);

    /**
     *
     */
    int updateByPrimaryKey(Teacher record);
    
    Teacher getByTeacherNo(@Param("teacherNo") String teacherNo);

    /**
     * 通过专业代码获取该专业所在院系的所有教师
     * @param majorNo 专业代码
     * @return List<Teacher>
     */
    List<Teacher> listTeacherByMajorNo(String majorNo);
}